///**
// * (C)2013 Exlu Corporation. All rights reserved.
// * 注意事項   :
// */
//package com.newtouch.mark.xls.dbimport;
//
//import java.io.File;
//import java.io.FileNotFoundException;
//import java.util.HashMap;
//import java.util.Map;
//
//import cn.exlu.wea.edk.db.connection.BasicDbConnectionFactory;
//import cn.exlu.wea.edk.db.connection.DbTransactionConnection;
//import cn.exlu.wea.edk.db.result.DbResultRow;
//import cn.exlu.wea.edk.db.result.DbResultSet;
//import cn.exlu.wea.edk.db.statement.DbPreparedStatement;
//import cn.exlu.wea.edk.xml.exception.ObjectNotInstanceException;
//import cn.exlu.wea.edk.xml.exception.XmlLoaderException;
//import cn.exlu.wea.edk.xml.loader.XmlLoader;
//
///**
// * @author Mark 
// * @version 1.0.1
// * 2013-6-10
// */
//public class XmlClientDb {
//
//    /**
//     * @param args
//     * @throws XmlLoaderException 
//     * @throws FileNotFoundException 
//     * @throws ObjectNotInstanceException 
//     */
//    public static void main(String[] args) throws FileNotFoundException, XmlLoaderException, ObjectNotInstanceException {
//        String custSql="select * from MST_USER_TBL ";
//        custSql+="WHERE $if(#userId#){ USER_PASSWORD like #:password:#}";
//        
//        Map<String,Object> map=new HashMap<String,Object>();
////        map.put("userId", 2);
////        map.put("password", "123456");
//        
//        String filePath="D:\\Dep\\workspace\\LpPj\\tools\\test\\java\\com\\newtouch\\mark\\xls\\dbimport\\db.xml";
//        XmlLoader loader=new XmlLoader(new File(filePath));
//        BasicDbConnectionFactory factory=(BasicDbConnectionFactory)loader.getInstance("dbfactory");
//        DbTransactionConnection dbconn=(DbTransactionConnection)factory.createDbConnnection();
//        
//        DbPreparedStatement dbpstatment=dbconn.getDbPreparedStatement(custSql,map); 
//        DbResultSet result=dbpstatment.queryByMap(map);
//        for(DbResultRow row :result){
//            System.out.print(row.getString("user_NUMBER") + " \t");
//            System.out.print(row.getString("user_name") + " \t");
//            System.out.println(row.getString("USER_PASSWORD"));
//        }
//        dbconn.close();
//    }
//
//}
